package tk.uodrad.apex.project.service.impl;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import tk.uodrad.apex.project.ex.ServiceException;
import tk.uodrad.apex.project.pojo.dto.PeopleAddNewDTO;
import tk.uodrad.apex.project.pojo.dto.PeopleUpdateDTO;
import tk.uodrad.apex.project.pojo.entity.People;
import tk.uodrad.apex.project.pojo.vo.PeopleListVO;
import tk.uodrad.apex.project.service.PeopleService;
import tk.uodrad.apex.project.mapper.PeopleMapper;
import org.springframework.stereotype.Service;
import tk.uodrad.apex.project.web.ServiceCode;

import java.util.Date;

/**
* @author Administrator
* @description 针对表【people_management】的数据库操作Service实现
* @createDate 2023-03-23 19:57:33
*/
@Slf4j
@Service
public class PeopleServiceImpl extends ServiceImpl<PeopleMapper, People> implements PeopleService{
    @Autowired
    private PeopleMapper peopleMapper;

    /**
    * 添加单个成员
    * @param peopleAddNewDTO 添加成员DTO
    */
    @Override
    public void save(PeopleAddNewDTO peopleAddNewDTO) {
        //新建一个People对象并将传入的DTO复制给People
        People people = new People();
        BeanUtils.copyProperties(peopleAddNewDTO, people);
        //给people对象赋值创建时间
        people.setGmtCreate(new Date());
        //创建MyBatis-plus提供的Wrappers类下的query()方法
        QueryWrapper<People> wrapper = Wrappers.query();
        //用eq方法用于判断数据库中是否有id_number等于当前People的idNumber（其他模块一般根据实际情况判断数据是否存在）
        wrapper.eq("id_number", people.getIdNumber());
        People selectOne = peopleMapper.selectOne(wrapper);
        if (selectOne != null) {
            String message = "新增数据失败，当前数据已存在！";
            log.warn(message);
            throw new ServiceException(ServiceCode.ERROR_CONFLICT, message);
        }
        //插入数据，并判断是否插入成功
        int rows = peopleMapper.insert(people);
        if (rows != 1) {
            String message = "服务器忙，请稍后再试！";
            log.warn(message);
            throw new ServiceException(ServiceCode.ERROR_INSERT, message);
        }
    }

    /**
     * 根据ID修改成员
     * @param peopleUpdateDTO 修改成员DTO
     */
    @Override
    public void updateById(PeopleUpdateDTO peopleUpdateDTO) {
        //根据传入的DTO中的ID查询数据库中是否存在该数据
        People peopleById = peopleMapper.selectById(peopleUpdateDTO.getId());
        if (peopleById == null) {
            String message = "修改数据失败，当前数据不存在！";
            log.warn(message);
            throw new ServiceException(ServiceCode.ERROR_NOT_FOUND, message);
        }
        //创建一个People对象，将传入的DTO复制给People对象
        People people = new People();
        BeanUtils.copyProperties(peopleUpdateDTO, people);
        //给people对象赋值创建时间
        people.setGmtModified(new Date());
        //更新数据，并判断是否更新成功
        int rows = peopleMapper.updateById(people);
        if (rows != 1) {
            String message = "服务器忙，请稍后再试！";
            log.warn(message);
            throw new ServiceException(ServiceCode.ERROR_UPDATE, message);
        }
    }

    /**
     * 分页查询成员列表
     * @param pageNum 第几页
     * @param pageSize 每页多少条数据
     * @param communityCode 小区编号
     * @return IPage<PeopleListVO> PeopleListVO分页对象
     */
    @Override
    public IPage<PeopleListVO> list(Integer pageNum, Integer pageSize, String communityCode) {
        Page<PeopleListVO> page = new Page<>(pageNum, pageSize);
        return peopleMapper.selectPageVo(page, communityCode);
    }

    /*
     * 统计人数
     * */
    @Override
    public Integer countPeople() {
        return peopleMapper.selectAllByIdInteger();
    }
}




